What is left and left outer join in SQL Server

join shbcf.ru